<template>
  <div>
    <div class="gva-search-box">
      <el-form :inline="true" :model="searchInfo" class="demo-form-inline" @keyup.enter="onSubmit">
        <el-form-item label="源数据库类型:" prop="srcDbType">
          <el-input v-model="formData.srcDbType" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="目标数据库类型:" prop="tgtDbType">
          <el-input v-model="formData.tgtDbType" placeholder="请输入" />
        </el-form-item>
        <el-form-item>
          <el-button type="primary" icon="search" @click="onSubmit">查询</el-button>
          <el-button icon="refresh" @click="onReset">重置</el-button>
        </el-form-item>
      </el-form>
    </div>
    <div class="gva-table-box">
      <div class="gva-btn-list">
        <el-button type="primary" icon="plus" @click="openDialog">新增</el-button>
        <el-popover v-model:visible="deleteVisible" placement="top" width="160">
          <p>确定要删除吗？</p>
          <div style="text-align: right; margin-top: 8px;">
            <el-button type="primary" link @click="deleteVisible = false">取消</el-button>
            <el-button type="primary" @click="deleteSelectedRow">确定</el-button>
          </div>
          <template #reference>
            <el-button icon="delete" style="margin-left: 10px;" :disabled="!multipleSelection.length" @click="deleteVisible = true">删除</el-button>
          </template>
        </el-popover>
      </div>

      <el-table
        ref="multipleTable"
        style="width: 100%"
        border
        :header-cell-style="{background:'#a3c6d2',color:'#849ba1'}"
        tooltip-effect="dark"
        :data="tableData"
        row-key="ID"
        @selection-change="handleSelectionChange"
      >
        <el-table-column type="selection" width="55" />
        <el-table-column align="left" label="源数据库类型" prop="srcDbType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="目标数据库类型" prop="tgtDbType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源数据类型" prop="srcFldType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源数据类型附加" prop="srcFldType1" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="目标字段类型" prop="tgtFldType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="目标数据类型附加" prop="tgtFldType1" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源数据转换方式" prop="srcFldConv" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="操作" width="150" fixed="right">
          <template #default="scope">
            <el-button type="primary" link icon="edit" class="table-button" @click="updateDbFldMapFunc(scope.row)">变更</el-button>
            <el-button type="primary" link icon="delete" @click="deleteRow(scope.row)">删除</el-button>
          </template>
        </el-table-column>
      </el-table>
      <div class="gva-pagination">
        <el-pagination
          layout="total, sizes, prev, pager, next, jumper"
          :current-page="page"
          :page-size="pageSize"
          :page-sizes="[10, 30, 50, 100]"
          :total="total"
          @current-change="handleCurrentChange"
          @size-change="handleSizeChange"
        />
      </div>
    </div>
    <el-dialog v-model="dialogFormVisible" :before-close="closeDialog" title="弹窗操作" class="dialog-mid">
      <el-form
        ref="elFormRef"
        class="x-form"
        :model="formData"
        label-position="right"
        :rules="rule"
        :inline="true"
      >
        <el-form-item label="源数据库类型:" prop="srcDbType">
          <el-select v-model="formData.srcDbType">
            <el-option v-for="item in srcDbTypeList" :key="item" :value="item" :label="item" />
          </el-select>
        </el-form-item>
        <el-form-item label="目标数据库类型:" prop="tgtDbType">
          <el-select v-model="formData.tgtDbType">
            <el-option v-for="item in tgtDbTypeList" :key="item" :value="item" :label="item" />
          </el-select>
        </el-form-item>
        <el-form-item label="源数据类型:" prop="srcFldType">
          <el-input v-model="formData.srcFldType" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="目标数据类型:" prop="tgtFldType">
          <el-input v-model="formData.tgtFldType" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="源数据类型附加:" prop="srcFldType1">
          <el-input v-model="formData.srcFldType1" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="目标数据类型附加:" prop="tgtFldType1">
          <el-input v-model="formData.tgtFldType1" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="源数据转换方式:" prop="srcFldConv">
          <el-input v-model="formData.srcFldConv" placeholder="请输入" />
        </el-form-item>
      </el-form>
      <template #footer>
        <div class="dialog-footer">
          <el-button @click="closeDialog">取 消</el-button>
          <el-button type="primary" @click="enterDialog">确 定</el-button>
        </div>
      </template>
    </el-dialog>
  </div>
</template>

<script>
export default {
  name: 'DbFldMap'
}
</script>

<script setup>
import {
  createDbFldMap,
  deleteDbFldMap,
  deleteDbFldMapByIds,
  updateDbFldMap,
  findDbFldMap,
  getDbFldMapList,
  getAllDbFldMaps
} from '@/api/dbFldMap'

import { getDict } from '@/utils/dictionary'
import { getDictFunc, formatDate, formatBoolean, filterDict } from '@/utils/format'
import { ElMessage, ElMessageBox } from 'element-plus'
import { ref, reactive } from 'vue'

const formData = ref({
  srcDbType: '',
  tgtDbType: '',
  srcFldConv: '',
  srcFldType: '',
  srcFldType1: '',
  tgtFldType: '',
  tgtFldType1: '',
})

const rule = reactive({
  srcDbType: [{
    required: true,
    message: '',
    trigger: ['input', 'blur'],
  }],
  tgtDbType: [{
    required: true,
    message: '',
    trigger: ['input', 'blur'],
  }],
  srcFldType: [{
    required: true,
    message: '',
    trigger: ['input', 'blur'],
  }],
  tgtFldType: [{
    required: true,
    message: '',
    trigger: ['input', 'blur'],
  }],
})

const elFormRef = ref()

const page = ref(1)
const total = ref(0)
const pageSize = ref(10)
const tableData = ref([])
const searchInfo = ref({})

const onReset = () => {
  searchInfo.value = {}
  getTableData()
}

const onSubmit = () => {
  page.value = 1
  pageSize.value = 10
  getTableData()
}

const handleSizeChange = (val) => {
  pageSize.value = val
  getTableData()
}

const handleCurrentChange = (val) => {
  page.value = val
  getTableData()
}

const getTableData = async() => {
  const table = await getDbFldMapList({ page: page.value, pageSize: pageSize.value, ...searchInfo.value })
  if (table.code === 0) {
    tableData.value = table.data.list
    total.value = table.data.total
    page.value = table.data.page
    pageSize.value = table.data.pageSize
  }
}

getTableData()


const setOptions = async() => {
}

setOptions()

const multipleSelection = ref([])
const handleSelectionChange = (val) => {
  multipleSelection.value = val
}

const deleteRow = (row) => {
  ElMessageBox.confirm('确定要删除吗?', '提示', {
    confirmButtonText: '确定',
    cancelButtonText: '取消',
    type: 'warning'
  }).then(() => {
    deleteDbFldMapFunc(row)
  })
}

const deleteVisible = ref(false)

const deleteSelectedRow = async() => {
  const ids = []
  if (multipleSelection.value.length === 0) {
    ElMessage({
      type: 'warning',
      message: '请选择要删除的数据'
    })
    return
  }
  multipleSelection.value &&
    multipleSelection.value.map(item => {
      ids.push(item.ID)
    })
  const res = await deleteDbFldMapByIds({ ids })
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '删除成功'
    })
    if (tableData.value.length === ids.length && page.value > 1) {
      page.value--
    }
    deleteVisible.value = false
    getTableData()
  }
}

const type = ref('')

const updateDbFldMapFunc = async(row) => {
  const res = await findDbFldMap({ ID: row.ID })
  type.value = 'update'
  if (res.code === 0) {
    formData.value = res.data.redbFldMap
    dialogFormVisible.value = true
  }
}

const deleteDbFldMapFunc = async(row) => {
  const res = await deleteDbFldMap({ ID: row.ID })
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '删除成功'
    })
    if (tableData.value.length === 1 && page.value > 1) {
      page.value--
    }
    getTableData()
  }
}

const dialogFormVisible = ref(false)

const openDialog = () => {
  type.value = 'create'
  dialogFormVisible.value = true
}

const closeDialog = () => {
  dialogFormVisible.value = false
  formData.value = {
    srcDbType: '',
    tgtDbType: '',
    srcFldConv: '',
    srcFldType: '',
    srcFldType1: '',
    tgtFldType: '',
    tgtFldType1: '',
  }
}
const enterDialog = async() => {
  elFormRef.value?.validate(async(valid) => {
    if (!valid) return
    let res
    switch (type.value) {
      case 'create':
        res = await createDbFldMap(formData.value)
        break
      case 'update':
        res = await updateDbFldMap(formData.value)
        break
      default:
        res = await createDbFldMap(formData.value)
        break
    }
    if (res.code === 0) {
      ElMessage({
        type: 'success',
        message: '创建/更改成功'
      })
      closeDialog()
      await getTableData()
    }
  })
}
const srcDbTypes = ref([])
const tgtDbTypes = ref([])
const srcDbTypeList = ref([])
const tgtDbTypeList = ref([])
const initDbFldMap = async() => {
  srcDbTypes.value = await getDict('odsDbType')
  tgtDbTypes.value = await getDict('tgtDbType')

  for (const oneDb of srcDbTypes.value) {
    srcDbTypeList.value.push(oneDb.label)
  }
  for (const oneDb of tgtDbTypes.value) {
    tgtDbTypeList.value.push(oneDb.label)
  }

}

const init = () => {
  initDbFldMap()
}

init()
</script>

<style>
</style>
